APPS.CS_SERVICEREQUEST_UTIL dependencies on CSI_I_PARTIES

Line 2484: csi_i_parties cip

2480: SELECT a.inventory_item_id
2481: INTO p_inventory_item_id
2482: FROM csi_item_instances a,
2483: mtl_system_items_b b,
2484: csi_i_parties cip
2485: WHERE a.instance_id = p_customer_product_id
2486: --AND a.owner_party_id = p_customer_id
2487: AND cip.party_id = p_customer_id
2488: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))

Line 2512: csi_i_parties cip

2508: SELECT a.inventory_item_id
2509: INTO p_inventory_item_id
2510: FROM csi_item_instances a,
2511: mtl_system_items_b b,
2512: csi_i_parties cip
2513: WHERE a.instance_id = p_customer_product_id
2514: -- AND a.owner_party_id = p_customer_id
2515: AND cip.party_id = p_customer_id
2516: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))

Line 2599: csi_i_parties cip

2595:
2596: SELECT 'x' INTO l_dummy
2597: FROM csi_item_instances a,
2598: mtl_system_items_b b,
2599: csi_i_parties cip
2600: WHERE a.instance_id = p_customer_product_id
2601: AND a.serial_number = p_current_serial_number
2602: -- AND a.owner_party_account_id = p_customer_id
2603: AND cip.party_id = p_customer_id

Line 2621: csi_i_parties cip

2617: ELSE
2618: SELECT 'x' INTO l_dummy
2619: FROM csi_item_instances a,
2620: mtl_system_items_b b,
2621: csi_i_parties cip
2622: WHERE a.instance_id = p_customer_product_id
2623: AND a.serial_number = p_current_serial_number
2624: -- AND a.owner_party_account_id = p_customer_id
2625: AND cip.party_id = p_customer_id

Line 3240: csi_i_parties cip

3236:
3237: SELECT 'x' INTO l_dummy
3238: FROM csi_item_instances a,
3239: mtl_system_items_b b,
3240: csi_i_parties cip
3241: WHERE a.instance_id = p_customer_product_id
3242: AND a.external_reference = p_external_reference
3243: AND cip.party_id = p_customer_id
3244: AND a.instance_id = cip.instance_id

Line 3258: csi_i_parties cip

3254:
3255: SELECT 'x' INTO l_dummy
3256: FROM csi_item_instances a,
3257: mtl_system_items_b b,
3258: csi_i_parties cip
3259: WHERE a.instance_id = p_customer_product_id
3260: AND a.external_reference = p_external_reference
3261: AND cip.party_id = p_customer_id
3262: AND a.instance_id = cip.instance_id

Line 3284: csi_i_parties cip

3280:
3281: SELECT 'X' INTO l_dummy
3282: FROM csi_item_instances a,
3283: mtl_system_items_b b,
3284: csi_i_parties cip
3285: WHERE b.inventory_item_id = p_inventory_item_id
3286: AND b.organization_id = p_inventory_org_id
3287: AND b.inventory_item_id = a.inventory_item_id
3288: AND cip.party_id = p_customer_id

Line 3301: csi_i_parties cip

3297:
3298: SELECT 'X' INTO l_dummy
3299: FROM csi_item_instances a,
3300: mtl_system_items_b b,
3301: csi_i_parties cip
3302: WHERE b.inventory_item_id = p_inventory_item_id
3303: AND b.organization_id = p_inventory_org_id
3304: AND b.inventory_item_id = a.inventory_item_id
3305: AND cip.party_id = p_customer_id

Line 9581: FROM csi_i_parties

9577: ) IS
9578: --
9579: CURSOR c_prod_rel IS
9580: SELECT 1
9581: FROM csi_i_parties
9582: WHERE instance_id = p_customer_product_id
9583: AND party_id = p_customer_id
9584: AND party_source_table = 'HZ_PARTIES';
9585:

Line 9586: l_party_id csi_i_parties.party_id % TYPE;

9582: WHERE instance_id = p_customer_product_id
9583: AND party_id = p_customer_id
9584: AND party_source_table = 'HZ_PARTIES';
9585:
9586: l_party_id csi_i_parties.party_id % TYPE;
9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9588: l_loc_type csi_item_instances.location_type_code % TYPE;
9589: l_external_ref csi_item_instances.external_reference % TYPE;
9590: l_serial_number csi_item_instances.serial_number % TYPE;