APPS.CS_SERVICEREQUEST_UTIL dependencies on CSI_I_PARTIES

Line 2482: csi_i_parties cip

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

Line 2510: csi_i_parties cip

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

Line 2597: csi_i_parties cip

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

Line 2619: csi_i_parties cip

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

Line 3238: csi_i_parties cip

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

Line 3256: csi_i_parties cip

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

Line 3282: csi_i_parties cip

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

Line 3299: csi_i_parties cip

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

Line 9529: FROM csi_i_parties

9525: ) IS
9526: --
9527: CURSOR c_prod_rel IS
9528: SELECT 1
9529: FROM csi_i_parties
9530: WHERE instance_id = p_customer_product_id
9531: AND party_id = p_customer_id
9532: AND party_source_table = 'HZ_PARTIES';
9533:

Line 9534: l_party_id csi_i_parties.party_id % TYPE;

9530: WHERE instance_id = p_customer_product_id
9531: AND party_id = p_customer_id
9532: AND party_source_table = 'HZ_PARTIES';
9533:
9534: l_party_id csi_i_parties.party_id % TYPE;
9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9536: l_loc_type csi_item_instances.location_type_code % TYPE;
9537: l_external_ref csi_item_instances.external_reference % TYPE;
9538: l_serial_number csi_item_instances.serial_number % TYPE;