DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on PO_VENDOR_SITES

Line 947: PO_VENDOR_SITES PVS

943: XLA_DISTRIBUTION_LINKS XDL,
944: AP_INVOICES AI,
945: AP_INVOICE_LINES AIL,
946: PO_VENDORS PV,
947: PO_VENDOR_SITES PVS
948: WHERE PBRV.source_distribution_id_num_1 = AID.invoice_distribution_id AND
949: AID.invoice_id = AI.invoice_id AND
950: AID.batch_id = APB.batch_id(+) AND
951: AI.vendor_id = PV.vendor_id(+) AND

Line 1110: PO_VENDOR_SITES PVS

1106: XLA_DISTRIBUTION_LINKS XDL,
1107: AP_INVOICES AI,
1108: AP_INVOICE_LINES AIL,
1109: PO_VENDORS PV,
1110: PO_VENDOR_SITES PVS
1111: WHERE PBRV.source_distribution_id_num_1 = APD.prepay_app_distribution_id AND
1112: AID.invoice_distribution_id = APD.invoice_distribution_id AND
1113: AID.invoice_id = AI.invoice_id AND
1114: AID.batch_id = APB.batch_id(+) AND

Line 1280: PO_VENDOR_SITES PVS,

1276: FROM PSA_BC_REPORT_V PBRV,
1277: PO_BC_DISTRIBUTIONS PBD,
1278: XLA_DISTRIBUTION_LINKS XDL,
1279: PO_VENDORS PV,
1280: PO_VENDOR_SITES PVS,
1281: PO_HEADERS PH,
1282: PO_LINES PL,
1283: PO_DISTRIBUTIONS PD,
1284: PO_LINE_LOCATIONS PLL

Line 1443: PO_VENDOR_SITES PVS,

1439: FROM PSA_BC_REPORT_V PBRV,
1440: PO_BC_DISTRIBUTIONS PBD,
1441: XLA_DISTRIBUTION_LINKS XDL,
1442: PO_VENDORS PV,
1443: PO_VENDOR_SITES PVS,
1444: PO_REQUISITION_HEADERS PRH,
1445: PO_REQUISITION_LINES PRL,
1446: PO_REQ_DISTRIBUTIONS PRD
1447: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND

Line 1611: PO_VENDOR_SITES PVS,

1607: FROM PSA_BC_REPORT_V PBRV,
1608: PO_BC_DISTRIBUTIONS PBD,
1609: XLA_DISTRIBUTION_LINKS XDL,
1610: PO_VENDORS PV,
1611: PO_VENDOR_SITES PVS,
1612: PO_HEADERS PH,
1613: PO_RELEASES PR,
1614: PO_LINES PL,
1615: PO_DISTRIBUTIONS PD,