DBA Data[Home] [Help]

APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';

19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
22:
23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

Line 1454: , csi_item_instances cii

1450: IS
1451: SELECT cii.instance_id,
1452: cqa.user_id
1453: FROM csm_mtl_onhand_qty_acc cqa
1454: , csi_item_instances cii
1455: , csi_instance_statuses iis
1456: , asg_user asg
1457: WHERE cqa.inventory_item_id=p_item_id
1458: AND cqa.organization_id=p_org_id