APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINE_TYPES_B

Line 3474: TABLE OF PO_LINE_TYPES_B.order_type_lookup_code%TYPE; --

3470: l_dist_num NumTab;
3471: l_rowcount NumTab;
3472:
3473: TYPE value_basis_tbl_type IS
3474: TABLE OF PO_LINE_TYPES_B.order_type_lookup_code%TYPE; --
3475: l_value_basis_tbl value_basis_tbl_type; --
3476:
3477: --
3478: l_return_status VARCHAR2(1);

Line 3625: , PO_LINE_TYPES_B PLT --

3621: , l_dist_amt_tbl --
3622: FROM
3623: PO_REQ_DISTRIBUTIONS_GT PRD
3624: , PO_REQ_LINES_GT PRL
3625: , PO_LINE_TYPES_B PLT --
3626: WHERE
3627: PRL.requisition_line_id = PRD.requisition_line_id
3628: AND PRL.requisition_header_id = p_document_id
3629: AND nvl(PRL.cancel_flag,'N') = 'N'

Line 5385: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt

5381: 0,
5382: p_sequence + ROWNUM,
5383: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
5384: 'PO_ALL_NO_ITEM'
5385: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
5386: where itm.inventory_item_id = pl.item_id
5387: and pl.item_id is not null
5388:
5389: and pl.po_line_id = pll.po_line_id

Line 6004: PO_LINE_TYPES_B PLT, -- bug3413891

6000: nvl(POLL.quantity,0) quantity,
6001: nvl(POL.item_id,-1) item_id,
6002: nvl( POLL.line_location_id,0) line_loc_id
6003: FROM PO_LINE_LOCATIONS_GT POLL,
6004: PO_LINE_TYPES_B PLT, -- bug3413891
6005: PO_LINES_GT POL,
6006: PO_DISTRIBUTIONS_GT POD
6007: WHERE POLL.po_line_id = POL.po_line_id
6008: AND POLL.line_location_id = POD.line_location_id

Line 6089: PO_LINE_TYPES_B PLT, -- bug3413891

6085: nvl(POLL.quantity,0) quantity,
6086: nvl(POL.item_id,0) item_id,
6087: nvl( POLL.line_location_id,0) line_loc_id
6088: FROM PO_LINE_LOCATIONS_GT POLL,
6089: PO_LINE_TYPES_B PLT, -- bug3413891
6090: PO_LINES POL,
6091: PO_DISTRIBUTIONS_GT POD --
6092: WHERE POLL.po_line_id = POL.po_line_id
6093: AND POLL.line_location_id = POD.line_location_id

Line 7686: , po_line_types_b PLT

7682: , 'PO_SUB_USER_RATE_TYPE'
7683: FROM dual
7684: WHERE exists ( SELECT 'Rate-based lines exist'
7685: FROM po_lines_gt POL
7686: , po_line_types_b PLT
7687: WHERE p_document_id = POL.po_header_id
7688: AND POL.line_type_id = PLT.line_type_id
7689: AND PLT.order_type_lookup_code = 'RATE'
7690: );

Line 9323: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_params_all fsp,po_line_types_b plt

9319: 0,
9320: p_sequence + ROWNUM,
9321: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
9322: 'PO_ALL_NO_ITEM'
9323: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_params_all fsp,po_line_types_b plt
9324: where fsp.org_id = ph.org_id
9325: and itm.inventory_item_id = pl.item_id
9326: and pl.item_id is not null
9327: and itm.organization_id = fsp.inventory_organization_id

Line 9372: from po_headers_gt ph,po_lines_gt pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt

9368: p_sequence + ROWNUM,
9369: substr(g_linemsg||g_delim||pl.line_num||g_delim||
9370: g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
9371: 'PO_ALL_NO_ITEM'
9372: from po_headers_gt ph,po_lines_gt pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
9373: where itm.inventory_item_id = pl.item_id
9374: and pl.item_id is not null
9375: and itm.organization_id = pll.ship_to_organization_id
9376: and itm.purchasing_enabled_flag = 'N'

Line 10941: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt

10937: 0,
10938: p_sequence + ROWNUM,
10939: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
10940: 'PO_ALL_NO_ITEM'
10941: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
10942: where itm.inventory_item_id = pl.item_id
10943: and pl.item_id is not null
10944: and itm.organization_id = fsp.inventory_organization_id
10945: and itm.purchasing_enabled_flag = 'N'