APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1729: -- logic to derive outsourced_assembly from mtl_system_items_b

1725: -----------------------------------------------------------------------
1726: --Start of Comments
1727: --Name: default_outsourced_assembly
1728: --Function:
1729: -- logic to derive outsourced_assembly from mtl_system_items_b
1730: -- in batch mode
1731: --Parameters:
1732: --IN:
1733: --p_item_id_tbl

Line 2091: -- default outsourced_assembly from mtl_system_items_b

2087: p_receipt_required_flag_tbl => x_line_locs.receipt_required_flag_tbl,
2088: x_accrue_on_receipt_flag_tbl => x_line_locs.accrue_on_receipt_flag_tbl
2089: );
2090:
2091: -- default outsourced_assembly from mtl_system_items_b
2092: default_outsourced_assembly
2093: (
2094: p_item_id_tbl => x_line_locs.ln_item_id_tbl,
2095: p_ship_to_organization_id_tbl => x_line_locs.ship_to_org_id_tbl,

Line 2546: FROM mtl_system_items

2542: INSERT INTO po_session_gt(key, num1, char1)
2543: SELECT p_key,
2544: p_index_tbl(i),
2545: inspection_required_flag
2546: FROM mtl_system_items
2547: WHERE p_item_id_tbl(i) IS NOT NULL
2548: AND x_inspection_required_flag_tbl(i) IS NULL
2549: AND inventory_item_id = p_item_id_tbl(i)
2550: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 2746: FROM mtl_system_items

2742: SELECT p_key,
2743: p_index_tbl(i),
2744: invoice_close_tolerance,
2745: receive_close_tolerance
2746: FROM mtl_system_items
2747: WHERE p_item_id_tbl(i) IS NOT NULL
2748: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2749: x_receive_close_tolerance_tbl(i) IS NULL)
2750: AND inventory_item_id = p_item_id_tbl(i)

Line 2791: FROM mtl_system_items

2787: SELECT p_key,
2788: p_index_tbl(i),
2789: invoice_close_tolerance,
2790: receive_close_tolerance
2791: FROM mtl_system_items
2792: WHERE p_item_id_tbl(i) IS NOT NULL
2793: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2794: x_receive_close_tolerance_tbl(i) IS NULL)
2795: AND inventory_item_id = p_item_id_tbl(i)

Line 3088: FROM mtl_system_items

3084: SELECT p_key,
3085: p_index_tbl(i),
3086: outside_operation_flag,
3087: nvl(stock_enabled_flag,'N')
3088: FROM mtl_system_items
3089: WHERE p_item_id_tbl(i) IS NOT NULL
3090: AND x_accrue_on_receipt_flag_tbl(i) IS NULL
3091: AND inventory_item_id = p_item_id_tbl(i)
3092: AND organization_id = p_ship_to_org_id_tbl(i);

Line 3248: FROM mtl_system_items item,

3244: INSERT INTO po_session_gt(key, num1, char1)
3245: SELECT p_key,
3246: p_index_tbl(i),
3247: uom.unit_of_measure
3248: FROM mtl_system_items item,
3249: mtl_units_of_measure uom
3250: WHERE p_item_id_tbl(i) IS NOT NULL
3251: AND p_ship_to_org_id_tbl(i) IS NOT NULL
3252: AND x_secondary_unit_of_meas_tbl(i) IS NULL