DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_LINES_ALL

Line 784: , po_lines_all pol

780: -- ,fsp.inventory_organization_id organization_id /* Commented by vkantamn for Bug#6083978 */
781: ,hl.inventory_organization_id organization_id /* Added by vkantamn for Bug#6083978 */
782: ,poll.ship_to_location_id location_id
783: from po_headers_all poh
784: , po_lines_all pol
785: , po_line_locations_all poll /*6843479*/
786: , mtl_system_items msi
787: , po_vendors pov
788: , hr_locations hl /* Added by vkantamn for Bug#6083978 */

Line 943: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )

939: and padi.ship_to_customer_id=c.customer_id;
940: -- End 5876390, 6012570
941:
942:
943: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
944: is
945: select service_type_code, sum(jpollt.tax_amount) service_tax_amount
946: from JAI_PO_LINE_LOCATIONS jpoll
947: ,jai_po_taxes jpollt