APPS.CSP_EXCESS_PARTS_PVT dependencies on CSP_SEC_INVENTORIES

Line 181: FROM CSP_PLANNING_PARAMETERS cpp,csp_sec_inventories csin

177: CURSOR PLANNING_NODE_REC IS
178: SELECT cpp.NODE_TYPE,cpp.ORGANIZATION_ID,cpp.SECONDARY_INVENTORY,cpp.CONDITION_TYPE,
179: cpp.planning_parameters_id,cpp.level_id,csin.parts_loop_id,csin.hierarchy_node_id,
180: csin.owner_resource_id, csin.owner_resource_type
181: FROM CSP_PLANNING_PARAMETERS cpp,csp_sec_inventories csin
182: WHERE LEVEL_ID LIKE p_level_id||'%'
183: and cpp.organization_id = csin.organization_id(+)
184: and cpp.secondary_inventory = csin.secondary_inventory_name(+);
185:

Line 573: update CSP_SEC_INVENTORIES

569:
570: end if;
571: End loop;
572:
573: update CSP_SEC_INVENTORIES
574: set last_excess_run_date = sysdate
575: where organization_id = p_organization_id
576: and secondary_inventory_name = nvl(p_subinventory_code, secondary_inventory_name);
577:

Line 695: update CSP_SEC_INVENTORIES

691: end if;
692:
693: end loop;
694:
695: update CSP_SEC_INVENTORIES
696: set last_excess_run_date = sysdate
697: where organization_id = p_organization_id;
698:
699: end if;

Line 807: update CSP_SEC_INVENTORIES

803: end if;
804:
805: end loop;
806:
807: update CSP_SEC_INVENTORIES
808: set last_excess_run_date = sysdate
809: where organization_id = p_organization_id
810: and secondary_inventory_name = nvl(curs.secondary_inventory_name, secondary_inventory_name);
811:

Line 1127: csp_sec_inventories csin

1123: mosv.subinventory_code,
1124: mosv.inventory_item_id,
1125: total_qoh excess_quantity
1126: from mtl_onhand_sub_v mosv,
1127: csp_sec_inventories csin
1128: where mosv.organization_id = p_organization_id
1129: and csin.organization_id = mosv.organization_id
1130: and csin.secondary_inventory_name = mosv.subinventory_code
1131: and csin.condition_type = 'B'

Line 1219: -- update CSP_SEC_INVENTORIES

1215: populate_excess_list(v_excess_part);
1216: end if;
1217: end loop;
1218:
1219: -- update CSP_SEC_INVENTORIES
1220: update CSP_SEC_INVENTORIES
1221: set last_excess_run_date = sysdate
1222: where organization_id = p_organization_id
1223: and secondary_inventory_name = nvl(p_subinventory_code, secondary_inventory_name);

Line 1220: update CSP_SEC_INVENTORIES

1216: end if;
1217: end loop;
1218:
1219: -- update CSP_SEC_INVENTORIES
1220: update CSP_SEC_INVENTORIES
1221: set last_excess_run_date = sysdate
1222: where organization_id = p_organization_id
1223: and secondary_inventory_name = nvl(p_subinventory_code, secondary_inventory_name);
1224:

Line 1997: CSP_SEC_INVENTORIES CSI

1993: select
1994: CSI.RETURN_ORGANIZATION_ID,
1995: CSI.RETURN_SUBINVENTORY_NAME
1996: from
1997: CSP_SEC_INVENTORIES CSI
1998: where
1999: CSI.SECONDARY_INVENTORY_NAME = cv_SUBINVENTORY_CODE
2000: and CSI.ORGANIZATION_ID = cv_ORGANIZATION_ID;
2001:

Line 2402: FROM csp_sec_inventories CINV,

2398: HLOC.STATE,
2399: HLOC.PROVINCE,
2400: HLOC.COUNTY,
2401: HLOC.COUNTRY
2402: FROM csp_sec_inventories CINV,
2403: HZ_LOCATIONS HLOC,
2404: csp_rs_cust_relations rcr,
2405: hz_cust_acct_sites_All cas,
2406: hz_cust_site_uses_all csu,