Banner
+ Reply to Thread
Results 1 to 3 of 3

Thread: “OB_RELEASE_INSTRUCTION” is connected / linked with the table “ORDER_RELEASE”
                  
    Bookmark and Share    
   

  1. #1
    Junior Member prabhurp83 is on a distinguished road
    Join Date
    Oct 2010
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    “OB_RELEASE_INSTRUCTION” is connected / linked with the table “ORDER_RELEASE”

    How the table “OB_RELEASE_INSTRUCTION” is connected / linked with the table “ORDER_RELEASE” to identify the respective releases of each release instruction in ob_line?

    Let me Explain my question.

    we can see order details in OB_ORDER_BASE
    and respective line details of OB_ORDER_BASE are presented in OB_LINE where ORDER_BASE_GID column is foreign key in OB_LINE.
    and respective release instruction of OB_LINE are presented in OB_RELEASE_INSTRUCTION where OB_LINE_GID column is foreign key in OB_RELEASE_INSTRUCTION.
    BUT, how I can identify the respective releases in ORDER_RELEASE/ ORDER_RELEASE_LINE of each OB_RELEASE_INSTRUCTION because I could see foreign key in ORDER_RELEASE/ ORDER_RELEASE_LINE as ORDER_BASE_GID only and not OB_LINE_GID /OB_RELEASE_INSTR_GID.

    I have noticed that when I delete the OB_RELEASE_INSTRUCTION through the Agent which is listen for an event “OB RELEASE INSTRUCTION - MODIFIED” and do the action “Order Base Line Release Instruction - Delete Release Instruction”, the respective release being deleted.
    How OTM understands/identify and deleted the particular release of OB_RELEASE_INSTRUCTION. Which field/column (in ORDER_RELEASE table) is being linked with the table “OB_RELEASE_INSTRUCTION”?

  2. #2
    Senior Member and Blogger josephliang is a jewel in the rough josephliang is a jewel in the rough josephliang is a jewel in the rough josephliang is a jewel in the rough
    Join Date
    Apr 2008
    Location
    Taiwan
    Posts
    738
    Blog Entries
    8
    Thanks
    44
    Thanked 324 Times in 218 Posts
    Rep Power
    10

    Re: “OB_RELEASE_INSTRUCTION” is connected / linked with the table “ORDER_RELEASE”

    SHIP_UNIT_LINE.ob_line_gid + SHIP_UNIT_LINE.ob_line_release_instr_seq => OB_RELEASE_INSTRUCTION table
    --
    Joseph Liang
    MavenWire APAC
    http://www.mavenwire.com/

  3. #3
    Junior Member prabhurp83 is on a distinguished road
    Join Date
    Oct 2010
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: “OB_RELEASE_INSTRUCTION” is connected / linked with the table “ORDER_RELEASE”

    Joseph,
    Yes, I have noticed it.
    thanks
    Prabhu


 

Similar Threads

  1. Replies: 18
    Last Post: April 18th, 2012, 14:51
  2. REP-300: policy predicate has error FROM ORDER_RELEASE O, ==> VIEW_SHIPMENT_ORDER_REL
    By Pranav in forum Reports / BI / FTI and Other Analytics
    Replies: 10
    Last Post: August 8th, 2011, 07:46
  3. BI Publisher -linked queries and function calls
    By DarkCloud67 in forum Reports / BI / FTI and Other Analytics
    Replies: 0
    Last Post: June 16th, 2011, 12:09
  4. Linked In Group
    By JoeMac in forum Resources and Resumes
    Replies: 6
    Last Post: May 20th, 2008, 11:56
  5. [SOLVED] Can Forms be linked with OTM
    By muthaharotm in forum Reports / BI / FTI and Other Analytics
    Replies: 2
    Last Post: August 30th, 2007, 04:43

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56