DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on RA_CUST_TRX_TYPES_ALL

Line 778: From RA_CUST_TRX_TYPES_ALL

774: p_object1_id1 IN NUMBER,
775: p_org_id IN NUMBER) IS
776: Select decode(p_type,'INV',Cust_trx_type_id,'CM',credit_memo_type_id),
777: post_to_gl
778: From RA_CUST_TRX_TYPES_ALL
779: Where SET_OF_BOOKS_ID = p_id
780: And org_id = p_org_id
781: And Cust_trx_type_id = p_object1_id1;
782:

Line 792: From RA_CUST_TRX_TYPES_ALL a

788: Select /*+ PARALLEL(a) */
789:
790: decode(p_type,'INV',Cust_trx_type_id,'CM',credit_memo_type_id),
791: post_to_gl
792: From RA_CUST_TRX_TYPES_ALL a
793: Where a.SET_OF_BOOKS_ID = p_id
794: And a.org_id = p_org_id
795: And a.type = 'INV'
796: And a.name = 'Invoice-OKS';

Line 2616: ra_cust_trx_types_all types

2612: IS
2613: SELECT count(*)
2614: FROM ra_customer_trx_all d, --Okx_customer_trx_v d
2615: ra_customer_trx_lines_all c, --Okx_cust_trx_lines_v c
2616: ra_cust_trx_types_all types
2617: WHERE c.interface_line_attribute1 = p_contract_number
2618: AND nvl(c.interface_line_attribute2,'-') = nvl(p_contract_modifier ,'-')
2619: AND c.Interface_line_attribute3 = to_char(p_bill_instance_number)
2620: AND c.Interface_line_context = 'OKS CONTRACTS'