Forum Stats

  • 3,838,667 Users
  • 2,262,392 Discussions
  • 7,900,730 Comments

Discussions

Base Tables to query Supplier Consumption advice in Oracle SaaS

Srinivas Veerla
Srinivas Veerla Member Posts: 8 Red Ribbon
edited Jan 23, 2018 8:56AM in Developer Solutions

Base Tables to query Supplier Consumption advice in Oracle SaaS

user8673352

Best Answer

  • Srinivas Veerla
    Srinivas Veerla Member Posts: 8 Red Ribbon
    edited Jan 23, 2018 8:55AM Answer ✓

    This Table Provides Information about Supplier Consumption Advice

    INV_CONS_ADVICE_HEADERS   -> AGREEMENT_HEADER_ID is the PO_HEADER_ID from PO_HEADERS_ALL

    INV_CONS_ADVICE_LINES

    PO_HEADERS_ALL

    These three tables would provide complete information.

    AGREEMENT_HEADER_ID

    user8673352

Answers

  • Srinivas Veerla
    Srinivas Veerla Member Posts: 8 Red Ribbon
    edited Jan 19, 2018 6:41AM

    I could see the Data in the below Tables.

    Yet to confirm whether I can find the exact data with these tables.

    1. PO_HEADERS_ALL

    2.INV_CONS_ADVICE_HEADERS

    3.INV_CONS_ADVICE_LINES

  • Srinivas Veerla
    Srinivas Veerla Member Posts: 8 Red Ribbon
    edited Jan 23, 2018 8:55AM Answer ✓

    This Table Provides Information about Supplier Consumption Advice

    INV_CONS_ADVICE_HEADERS   -> AGREEMENT_HEADER_ID is the PO_HEADER_ID from PO_HEADERS_ALL

    INV_CONS_ADVICE_LINES

    PO_HEADERS_ALL

    These three tables would provide complete information.

    AGREEMENT_HEADER_ID

    user8673352