DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on PO_REQUISITION_LINES_ALL

Line 1095: po_requisition_lines_all pl,

1091: new_quantity,
1092: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1093: old_quantity
1094: FROM po_req_distributions_all pd,
1095: po_requisition_lines_all pl,
1096: mrp_system_items items,
1097: mtl_supply ms,
1098: mrp_form_query list,
1099: mrp_sub_inventories msi

Line 1204: po_requisition_lines_all prl,

1200: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1201: prl.quantity) old_quantity
1202: FROM mrp_system_items items,
1203: po_req_distributions_all pd,
1204: po_requisition_lines_all prl,
1205: mtl_supply ms,
1206: mrp_form_query list,
1207: mrp_sub_inventories msi
1208: WHERE (arg_res_level = 1

Line 1265: FROM po_requisition_lines_all pl,

1261: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1262: pl.quantity) new_quantity,
1263: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1264: pl.quantity) old_quantity
1265: FROM po_requisition_lines_all pl,
1266: po_req_distributions_all pd,
1267: mrp_system_items items,
1268: mtl_supply ms,
1269: mrp_form_query list,

Line 1487: po_requisition_lines_all pl,

1483: SUM((nvl(ms.to_org_primary_quantity,0)* pd.req_line_quantity/pl.quantity) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1484: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1485: 0 old_quantity
1486: FROM po_req_distributions_all pd,
1487: po_requisition_lines_all pl,
1488: mrp_system_items items,
1489: mtl_supply ms,
1490: mrp_form_query list,
1491: mrp_sub_inventories msi