APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINE_TYPES_B

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

1684: l_dist_num NumTab;
1685: l_rowcount NumTab;
1686:
1687: TYPE value_basis_tbl_type IS
1688: TABLE OF PO_LINE_TYPES_B.order_type_lookup_code%TYPE; --
1689: l_value_basis_tbl value_basis_tbl_type; --
1690:
1691: --
1692: l_return_status VARCHAR2(1);

Line 1828: , PO_LINE_TYPES_B PLT --

1824: , l_dist_amt_tbl --
1825: FROM
1826: PO_REQ_DISTRIBUTIONS_GT PRD
1827: , PO_REQ_LINES_GT PRL
1828: , PO_LINE_TYPES_B PLT --
1829: WHERE
1830: PRL.requisition_line_id = PRD.requisition_line_id
1831: AND PRL.requisition_header_id = p_document_id
1832: AND nvl(PRL.cancel_flag,'N') = 'N'

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

3544: 0,
3545: p_sequence + ROWNUM,
3546: substr(g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
3547: 'PO_ALL_NO_ITEM'
3548: from po_releases_gt por,po_lines pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
3549: where itm.inventory_item_id = pl.item_id
3550: and pl.item_id is not null
3551:
3552: and pl.po_line_id = pll.po_line_id

Line 4081: PO_LINE_TYPES_B PLT, -- bug3413891

4077: nvl(POLL.quantity,0) quantity,
4078: nvl(POL.item_id,-1) item_id,
4079: nvl( POLL.line_location_id,0) line_loc_id
4080: FROM PO_LINE_LOCATIONS_GT POLL,
4081: PO_LINE_TYPES_B PLT, -- bug3413891
4082: PO_LINES_GT POL,
4083: PO_DISTRIBUTIONS_GT POD
4084: WHERE POLL.po_line_id = POL.po_line_id
4085: AND POLL.line_location_id = POD.line_location_id

Line 4162: PO_LINE_TYPES_B PLT, -- bug3413891

4158: nvl(POLL.quantity,0) quantity,
4159: nvl(POL.item_id,0) item_id,
4160: nvl( POLL.line_location_id,0) line_loc_id
4161: FROM PO_LINE_LOCATIONS_GT POLL,
4162: PO_LINE_TYPES_B PLT, -- bug3413891
4163: PO_LINES POL,
4164: PO_DISTRIBUTIONS_GT POD --
4165: WHERE POLL.po_line_id = POL.po_line_id
4166: AND POLL.line_location_id = POD.line_location_id

Line 5350: , po_line_types_b PLT

5346: , 'PO_SUB_USER_RATE_TYPE'
5347: FROM dual
5348: WHERE exists ( SELECT 'Rate-based lines exist'
5349: FROM po_lines_gt POL
5350: , po_line_types_b PLT
5351: WHERE p_document_id = POL.po_header_id
5352: AND POL.line_type_id = PLT.line_type_id
5353: AND PLT.order_type_lookup_code = 'RATE'
5354: );

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

6663: 0,
6664: p_sequence + ROWNUM,
6665: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
6666: 'PO_ALL_NO_ITEM'
6667: from po_headers_gt ph, po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
6668: where itm.inventory_item_id = pl.item_id
6669: and pl.item_id is not null
6670: and itm.organization_id = fsp.inventory_organization_id
6671: and itm.purchasing_enabled_flag = 'N'

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

6710: p_sequence + ROWNUM,
6711: substr(g_linemsg||g_delim||pl.line_num||g_delim||
6712: g_shipmsg||g_delim||pll.shipment_num||g_delim||l_textline,1,240),
6713: 'PO_ALL_NO_ITEM'
6714: from po_headers_gt ph,po_lines_gt pl,po_line_locations_gt pll,mtl_system_items itm,po_line_types_b plt
6715: where itm.inventory_item_id = pl.item_id
6716: and pl.item_id is not null
6717: and itm.organization_id = pll.ship_to_organization_id
6718: and itm.purchasing_enabled_flag = 'N'

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

7807: 0,
7808: p_sequence + ROWNUM,
7809: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
7810: 'PO_ALL_NO_ITEM'
7811: from po_headers_gt ph,po_lines_gt pl,mtl_system_items itm,financials_system_parameters fsp,po_line_types_b plt
7812: where itm.inventory_item_id = pl.item_id
7813: and pl.item_id is not null
7814: and itm.organization_id = fsp.inventory_organization_id
7815: and itm.purchasing_enabled_flag = 'N'